import pandas as pd
list=[[110,10,30],[10,103,32],[25,85,45],[95,85,65]]
index=['王蒙','李镇','赵乐','刘夜']
columns=['语文','数学','英语']
df=pd.DataFrame(list, index, columns)
print('保存到"score1"工作表中的数据: \n',df)
writer=pd.ExcelWriter('Score.xlsx')
df.to_excel(writer, sheet_name='score1')
df.iloc[0]=[111,25,41]
print('保存到"score2"工作表中的数据: \n', df)
df.to_excel(writer, sheet_name='score2')
writer._save()
df1=pd.read_excel('Score.xlsx', sheet_name=['score1','score2'],index_col=0)
print('导入的数据: \n', df1)